USE F12I4DAB1H2Gr2;
GO

SELECT [Node].[ID] As 'Node_ID'
      ,[Node].[Address] As 'Node_Address'
      ,[Node].[Country] As 'Node_Country'
	  ,[Node].[Description] As 'Node_Description'
	  ,[Pool].[ID] As 'Pool_ID'
	  ,[Pool].[Fluctuation] As 'Pool_Fluctuation'
	  ,[Park].[ID] As 'Park_ID'
	  ,[Park].[Location] As 'Park_Location'
	  ,[Park].[OnLand] As 'Park_OnLand'
	  ,[Windmill].[ID] As 'Windmill_ID'
	  ,[Windmill].[Name] As 'Windmill_Name'
	  ,[Windmill].[Location] As 'Windmill_Location'

FROM [Node]
LEFT JOIN [Pool]
ON [Node].[ID]=[Pool].[Node]
LEFT JOIN [Park]
ON [Pool].[ID]=[Park].[Pool]
LEFT JOIN [Windmill]
ON [Park].[ID]=[Windmill].[Park]
ORDER BY [Node].[ID]